Tabela LEventICD

Definicja tabeli LEventICD

Name

LEventICD

Code

LEventICD

Comment

PL: Przyporzadkowanie na potrzeby kodowania
EN: Assignation coding data for event


Lista kolumn tabeli LEventICD

Name

Code

LEventICDID

LEventICDID

EventID

EventID

ICDID

ICDID

DiagnosisTypeID

DiagnosisTypeID

DiagnosisKindID

DiagnosisKindID

ReferralID

ReferralID

LEv_LEventICDID

LEv_LEventICDID

DiagnosisInjuryID

DiagnosisInjuryID

DiagnosisCharacterID

DiagnosisCharacterID

SequenceNo

SequenceNo

Rank

Rank

Comment

Comment

RareDiseaseCode

RareDiseaseCode

FirstOccurence

FirstOccurence

StartDT

StartDT

IsImportant

IsImportant

Commentary

Commentary

StatusID

StatusID

StatusComment

StatusComment


Kolumna LEventICDID tabeli LEventICD

Definicja kolumny LEventICDID tabeli LEventICD

Name

LEventICDID

Code

LEventICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli LEventICD

Definicja kolumny EventID tabeli LEventICD

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ICDID tabeli LEventICD

Definicja kolumny ICDID tabeli LEventICD

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DiagnosisTypeID tabeli LEventICD

Definicja kolumny DiagnosisTypeID tabeli LEventICD

Name

DiagnosisTypeID

Code

DiagnosisTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DiagnosisKindID tabeli LEventICD

Definicja kolumny DiagnosisKindID tabeli LEventICD

Name

DiagnosisKindID

Code

DiagnosisKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReferralID tabeli LEventICD

Definicja kolumny ReferralID tabeli LEventICD

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LEv_LEventICDID tabeli LEventICD

Definicja kolumny LEv_LEventICDID tabeli LEventICD

Name

LEv_LEventICDID

Code

LEv_LEventICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DiagnosisInjuryID tabeli LEventICD

Definicja kolumny DiagnosisInjuryID tabeli LEventICD

Name

DiagnosisInjuryID

Code

DiagnosisInjuryID

Data Type

NUMBER(10)

Mandatory

No

Comment

uraz


Kolumna DiagnosisCharacterID tabeli LEventICD

Definicja kolumny DiagnosisCharacterID tabeli LEventICD

Name

DiagnosisCharacterID

Code

DiagnosisCharacterID

Data Type

NUMBER(10)

Mandatory

No

Comment

charakter choroby


Kolumna SequenceNo tabeli LEventICD

Definicja kolumny SequenceNo tabeli LEventICD

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Rank tabeli LEventICD

Definicja kolumny Rank tabeli LEventICD

Name

Rank

Code

Rank

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comment tabeli LEventICD

Definicja kolumny Comment tabeli LEventICD

Name

Comment

Code

Comment

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna RareDiseaseCode tabeli LEventICD

Definicja kolumny RareDiseaseCode tabeli LEventICD

Name

RareDiseaseCode

Code

RareDiseaseCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod choroby rzadkiej w klasyfikacji Orphanet


Kolumna FirstOccurence tabeli LEventICD

Definicja kolumny FirstOccurence tabeli LEventICD

Name

FirstOccurence

Code

FirstOccurence

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Diagnoza pierwszorazowa


Kolumna StartDT tabeli LEventICD

Definicja kolumny StartDT tabeli LEventICD

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

data wprowadzenia diagnozy


Kolumna IsImportant tabeli LEventICD

Definicja kolumny IsImportant tabeli LEventICD

Name

IsImportant

Code

IsImportant

Data Type

NUMBER(1)

Mandatory

No

Comment

Istotnosc diagnozy 0/1


Kolumna Commentary tabeli LEventICD

Definicja kolumny Commentary tabeli LEventICD

Name

Commentary

Code

Commentary

Data Type

CLOB

Mandatory

No

Comment

Komentarz do diagnozy


Kolumna StatusID tabeli LEventICD

Definicja kolumny StatusID tabeli LEventICD

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status pacjenta na liscie


Kolumna StatusComment tabeli LEventICD

Definicja kolumny StatusComment tabeli LEventICD

Name

StatusComment

Code

StatusComment

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Komentarz dotyczacy ustawienia statusu


Lista kluczy tabeli LEventICD

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LEventICD

Definicja klucza Identifier_1 tabeli LEventICD

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment